SELECT newurl FROM URLRedirect with (nolock) WHERE division = 1 and OldURL = 'sku=31378&title=20085-up-club-car-precedent-|-onward-|-tempo-titanium-dash-replacement'